Hệ thống thông tin sinh viên trong C#

5.190 lượt xem;
1
2 using System.Diagnostics;
3 using System;
4 using System.Xml.Linq;
5 using System.Windows.Forms;
6 using System.Collections;
7 using System.Drawing;
8 using Microsoft.VisualBasic;
9 using System.Data;
10 using System.Collections.Generic;
11 using System.Linq;
12
13
14
15 namespace Grading_System
16 {
17     public class gradeclass
18     {
19         string mDataPath;
20         public static gradeclass DataModule;
21         
22         private System.Data.OleDb.OleDbConnection GetConnection()
23         {
24             return new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + mDataPath + "\\grade1.accdb");
25         }
26         
27         public gradeclass(string sDatapath)
28         {
29             this.mDataPath = sDatapath;
30             gradeclass.DataModule = this;
31             
32         }
33         
34         public DataSet GetLoad()
35         {
36             return this.GetLoad("data1");
37         }
38         
39         public DataSet GetLoad(string sortfield)
40         {
41             
42             System.Data.OleDb.OleDbConnection conn = GetConnection();
43             DataSet ds = new DataSet();
44             
45             try
46             {
47                 
48                 // Dim sql As String = "SELECT ID data1 as [Firstname],data2 as [Lastname],data3 as [20],data4 as [EG],data5 as [1st-10%],data6 as [50pt],data7 as [EG1],data8 as [2nd-10%],data9 as [50pts],data10 as [EG2],data11 as [20%],data12 as [100pt],data13 as [EG3],data14 as [30%],data15 as [100],data16 as [EG4],data17 as [2nd-30%],data18 as [PrelimGrade],data19 as [Remarks]FROM Table1 order by " + sortfield
49                 string sql = "SELECT STUDENTID,data1 AS Firstname, data2 AS Lastname," + "data3 AS 20, data4 AS EG, data5 AS [1st-10%], data6 AS 50pt," + "data7 AS EG1, data8 AS [2nd-10%], data9 AS 50pts, data10 AS EG2," + "data11 AS [20%], data12 AS 100pt, data13 AS EG3, data14 AS [30%]," + "data15 AS 100, data16 AS EG4, data17 AS [2nd-30%], data18 AS PrelimGrade," + "data19 AS Remarks FROM Table1 ORDER BY ID";
50                 
51                 System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
52                 try
53                 {
54                     da.Fill(ds, "grade1");
55                 }
56                 finally
57                 {
58                     da.Dispose();
59                 }
60                 return ds;
61             }
62             finally
63             {
64                 conn.Close();
65                 conn.Dispose();
66             }
67         }
68         public void RefreshDGV()
69         {
70             
71             System.Data.OleDb.OleDbConnection conn = GetConnection();
72             string sql = default(string);
73             sql = "SELECT STUDENTID,data1 AS Firstname, data2 AS Lastname," + "data3 AS 20, data4 AS EG, data5 AS [1st-10%], data6 AS 50pt," + "data7 AS EG1, data8 AS [2nd-10%], data9 AS 50pts, data10 AS EG2," + "data11 AS [20%], data12 AS 100pt, data13 AS EG3, data14 AS [30%]," + "data15 AS 100, data16 AS EG4, data17 AS [2nd-30%], data18 AS PrelimGrade," + "data19 AS Remarks FROM Table1 ORDER BY ID";
74             
75             System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
76             DataTable dt = new DataTable("grade1");
77             da.Fill(dt);
78             Form1.Default.DataGridView1.DataSource = dt;
79         }
80         public void clearall()
81         {
82             Form1.Default.TextBox1.Text = "";
83             Form1.Default.TextBox2.Text = "";
84             Form1.Default.TextBox3.Text = "";
85             Form1.Default.TextBox4.Text = "";
86             Form1.Default.TextBox5.Text = "";
87             Form1.Default.TextBox6.Text = "";
88             Form1.Default.TextBox7.Text = "";
89             Form1.Default.TextBox8.Text = "";
90             Form1.Default.TextBox9.Text = "";
91             Form1.Default.TextBox10.Text = "";
92             Form1.Default.TextBox11.Text = "";
93             Form1.Default.TextBox12.Text = "";
94             Form1.Default.TextBox13.Text = "";
95             Form1.Default.TextBox14.Text = "";
96             Form1.Default.TextBox15.Text = "";
97             Form1.Default.TextBox16.Text = "";
98             Form1.Default.TextBox17.Text = "";
99             Form1.Default.TextBox18.Text = "";
100             Form1.Default.TextBox19.Text = "";
101             Form1.Default.STUDID.Text = "";
102             
103             
104         }
105         
106         public DataSet SaveItem()
107         {
108             return this.SaveItem("data1");
109         }
110         public DataSet SaveItem(string sortfield)
111         {
112             
113             System.Data.OleDb.OleDbConnection conn = GetConnection();
114             
115             try
116             {
117                 
118                 string SQL = default(string);
119                 
120                 SQL = "INSERT INTO TABLE1 (STUDENTID, DATA1, DATA2, DATA3, DATA4, DATA5,DATA6, DATA7," + "DATA8, DATA9, DATA10, DATA11, DATA12, DATA13, DATA14, DATA15, DATA16, DATA17, DATA18," + "DATA19) VALUES(@STUDENTID, @DATA1, @DATA2, @DATA3, @DATA4, @DATA5,@DATA6, @DATA7,DATA8, @DATA9," + "@DATA10, @DATA11, @DATA12, @DATA13, @DATA14, @DATA15, @DATA16, @DATA17, @DATA18, @DATA19)";
121                 System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn);
122                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
123                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
124                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
125                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
126                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
127                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
128                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
129                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
130                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
131                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
132                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
133                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
134                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
135                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
136                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
137                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
138                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
139                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
140                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
141                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
142                 
143                 conn.Open();
144                 cmd.ExecuteNonQuery();
145                 conn.Close();
146                 MessageBox.Show("New data is Added!");
147                 
148                 Form1.Default.TextBox1.Text = "";
149                 Form1.Default.TextBox2.Text = "";
150                 Form1.Default.TextBox3.Text = "";
151                 Form1.Default.TextBox4.Text = "";
152                 Form1.Default.TextBox5.Text = "";
153                 Form1.Default.TextBox6.Text = "";
154                 Form1.Default.TextBox7.Text = "";
155                 Form1.Default.TextBox8.Text = "";
156                 Form1.Default.TextBox9.Text = "";
157                 Form1.Default.TextBox10.Text = "";
158                 Form1.Default.TextBox11.Text = "";
159                 Form1.Default.TextBox12.Text = "";
160                 Form1.Default.TextBox13.Text = "";
161                 Form1.Default.TextBox14.Text = "";
162                 Form1.Default.TextBox15.Text = "";
163                 Form1.Default.TextBox16.Text = "";
164                 Form1.Default.TextBox17.Text = "";
165                 Form1.Default.TextBox18.Text = "";
166                 Form1.Default.TextBox19.Text = "";
167                 Form1.Default.STUDID.Text = "";
168                 
169                 RefreshDGV();
170                 
171             }
172             finally
173             {
174                 conn.Close();
175                 conn.Dispose();
176             }
177             
178             return default(DataSet);
179         }
180         
181         public DataSet navigate()
182         {
183             return this.navigate("data2");
184         }
185         public DataSet navigate(string sortfield)
186         {
187             
188             System.Data.OleDb.OleDbConnection conn = GetConnection();
189             DataSet ds = new DataSet();
190             
191             try
192             {
193                 
194                 int inc;
195                 int MaxRows;
196                 
197                 string sql = "select * from table1";
198                 System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
199                 
200                 try
201                 {
202                     da.Fill(ds, "grade1");
203                     MaxRows = ds.Tables["grade1"].Rows.Count;
204                     inc = -1;
205                     
206                     
207                 }
208                 finally
209                 {
210                     da.Dispose();
211                 }
212                 
213                 return ds;
214             }
215             finally
216             {
217                 conn.Close();
218                 conn.Dispose();
219             }
220         }
221         public DataSet deldata()
222         {
223             return this.deldata("data2");
224         }
225         public DataSet deldata(string sortfield)
226         {
227             
228             System.Data.OleDb.OleDbConnection conn = GetConnection();
229             DataSet ds = new DataSet();
230             
231             try
232             {
233                 
234                 int inc;
235                 int MaxRows;
236                 
237                 //Dim sql As String = "select * from table1"
238                 //Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, conn)
239                 
240                 try
241                 {
242
243                     string sqldelete = default(string);
244                     sqldelete = "DELETE * FROM table1 WHERE STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
245                     System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqldelete, conn);
246                     
247                     // Gets the records from the table and fills our adapter with those.
248                     DataTable dt = new DataTable("grade1");
249                     da.Fill(dt);
250                     MessageBox.Show("Data has been deleted");
251                     clearall();
252                     
253                     Form1.Default.DataGridView1.DataSource = dt;
254                     
255                     RefreshDGV();
256                     
257                 }
258                 finally
259                 {
260                     //da.Dispose()
261                 }
262                 
263                 return ds;
264             }
265             finally
266             {
267                 conn.Close();
268                 conn.Dispose();
269             }
270         }
271         
272         public DataSet updtedata()
273         {
274             return this.updtedata("data0");
275         }
276         public DataSet updtedata(string sortfield)
277         {
278             
279             System.Data.OleDb.OleDbConnection conn = GetConnection();
280             DataSet ds = new DataSet();
281             
282             try
283             {
284                 
285                 string sqlupdate = default(string);
286                 
287                 sqlupdate = "UPDATE Table1 set STUDENTID=@STUDENTID, data1=@data1, data2=@data2, data3=@data3, data4=@data4," + "data5=@data5, data6=@data6, data7=@data7, data8=@data8, data9=@data9, data10=@data10," + "data11=@data11, data12=@data12, data13=@data13, data14=@data14, data15=@data15, data16=@data16," + "data17=@data17, data18=@data18, data19=@data19 where STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
288                 System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sqlupdate, conn);
289                 
290                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
291                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
292                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
293                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
294                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
295                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
296                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
297                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
298                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
299                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
300                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
301                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
302                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
303                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
304                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
305                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
306                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
307                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
308                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
309                 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
310                 
311                 conn.Open();
312                 cmd.ExecuteNonQuery();
313                 conn.Close();
314                 MessageBox.Show("Data Updated in the Database");
315                 RefreshDGV();
316                 
317             }
318             finally
319             {
320             }
321             return ds;
322         }
323         
324         
325     }
326 }


Dim sql As String = "SELECT ID data1 as [Firstname],data2 as [Lastname],data3 as [20],data4 as [EG],data5 as [1st-10%],data6 as [50pt],data7 as [EG1],data8 as [2nd-10%],data9 as [50pts],data10 as [EG2],data11 as [20%],data12 as [100pt],data13 as [EG3],data14 as [30%],data15 as [100],data16 as [EG4],data17 as [2nd-30%],data18 as [PrelimGrade],data19 as [Remarks]FROM Table1 order by " + sortfield

Dim sql As String = "select * from table1"

Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, conn)

Gets the records from the table and fills our adapter with those.

da.Dispose()




Hệ thống thông tin sinh viên trong C# 5.190 lượt xem

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

94 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

99 lượt xem

Đếm nguyên âm và phụ âm

135 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

213 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

176 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

186 lượt xem